CREATE TABLE [dbo].[DnnProduct_SearchItemWordPosition]
(
[SearchItemWordPositionID] [int] NOT NULL IDENTITY(1, 1),
[SearchItemWordID] [int] NOT NULL,
[ContentPosition] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_SearchItemWordPosition] ADD CONSTRAINT [PK_DnnProduct_SearchItemWordPosition] PRIMARY KEY CLUSTERED  ([SearchItemWordPositionID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_SearchItemWordPosition] WITH NOCHECK ADD CONSTRAINT [FK_DnnProduct_SearchItemWordPosition_DnnProduct_SearchItemWord] FOREIGN KEY ([SearchItemWordID]) REFERENCES [dbo].[DnnProduct_SearchItemWord] ([SearchItemWordID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
